package com.dingding.service.recruit.core.sql;

/**
 * 
 * @ClassName: DriverRecruitSQL 
 * @Description: 司机招募SQL专用类
 * @author YHQ
 * @date 2016年11月11日 下午4:07:08
 * @since V2.5.6
 * 
 */
public class DriverRecruitSQL {

	/**
	 * 
	 * @author YHQ
	 * @since V2.5.6
	 * @Description 获取司机招募城市
	 * 
	 */
	public static final String DRIVER_RECRUIT_CITY = "SELECT d.cityId,c.cityName FROM dd_ref_city d INNER JOIN city c ON d.cityId = c.cityId WHERE d.type = 1";
	
	/**
	 * 
	 * @author YHQ
	 * @since V2.5.6
	 * @Description 获取司机招募报名信息
	 * 
	 */
	public static final String GET_DRIVER_RECRUIT_INFO = "SELECT d.carType,d.cityId,d.driLicDate,d.idCard,d.licDataNo,d.name,d.telPhone,c.cityName,d.recId FROM dd_recruituser d LEFT JOIN city c ON c.cityId = d.cityId WHERE d.telPhone = ?";
	
	/**
	 * 
	 * @author YHQ
	 * @since V2.5.6
	 * @Description 根据手机号获取审核状态
	 * 
	 */
	public static final String GET_DRIVER_RECRUIT_STATUS = "SELECT d.examStatus FROM dd_recruituser d WHERE d.telPhone = ?";
	
}
